MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Object Name = 15414

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Culture, Artist Nationality, Object Begin Date, Object End Date, Credit Line, Country, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
345941 89.2.170 0 0 500564 Musical Instruments 18 Lyre Guitar 15414 Lyre Guitar French 7         Maker 1 attributed to Jean Charles French, Marseilles active 1783–1786   Charles, Jean 47638 French 2 1783 1786 ca. 1785 1780 1790 Wood 25 ca. L. 80 cm (31-1/2 in.), ca. Max. W. 47.5 cm (18-11/16 in.), ca. Max D. 12 cm (4-11/16 in.) Gift of Joseph W. Drexel, 1889   Marseilles? 2118     France 9             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
345952 89.2.183 0 1 500575 Musical Instruments 18 Lyre Guitar 15414 Lyre Guitar probably Italian 117                           19th century 1801 1900 Wood, various materials. 53961 Total length: 83 cm (32-9/16 in.), Maximun width: 35.3 cm (13-15/16 in.), Depth at tail: 9.1 cm (3-9/16 in.), Vibrating length: 63.2 cm (24-7/8 in.) Gift of Joseph W. Drexel, 1889         Italy? 510             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
346999 89.4.1056 0 1 501643 Musical Instruments 18 Lyre Guitar 15414 Lyre Guitar Italian 36         Maker 1   Gennaro Fabricatore Italian, Naples ca. 1750–1832 Naples   Fabricatore Gennaro 47735 Italian (Naples) 3483 1750 1832 1807 1807 1807 Spruce, maple, ebony 54088 Total length 80.7 cm., Max width 37.4 cm., Depth at tail 9.4 cm., Vibrating length 63.5 cm. The Crosby Brown Collection of Musical Instruments, 1889   Naples 436     Italy 14             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
347008 89.4.1074 0 1 501653 Musical Instruments 18 Lyre Guitar 15414 Lyre Guitar French 7         Maker 1   Joseph-Louis Germain French, Mirecourt 1822–1870 Mirecourt   Germain 47749 French 2 1822 1870 ca. 1840 1835 1845 Wood, mother-of-pearl, gut, metal wound on silk 54365 L. 36 in. L. of fingerboard (nut to base) 39.8 cm W. of fingerboard at base 5.9 cm L. of body 43. cm W. of body at widest 33.1 cm D. of body at neck 7.2 cm, at foot 9.2 cm L. of Strings vibrating 65.1 cm Diam. of soundhole +/- 6cm The Crosby Brown Collection of Musical Instruments, 1889         France 9             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
347254 89.4.1346 0 0 501912 Musical Instruments 18 Lyre Guitar 15414 Lyre Guitar French 7                           late 19th century 1850 1900 Wood, metal 6120 l. 1 ft. 11 in., W. 10-1/4 in. The Crosby Brown Collection of Musical Instruments, 1889         France 9             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
348056 89.4.2590 0 1 502744 Musical Instruments 18 Lyre Guitar 15414 Lyre Guitar French 7                           early 19th century 1800 1825 Spruce, cedar, ebony, brass, ivory 54654 Total L. 85.1 cm.; String L. 64.7 cm. The Crosby Brown Collection of Musical Instruments, 1889         France 9             Chordophone-Lute-plucked 960   Metropolitan Museum of Art, New York, NY 1
348788 1998.121 1 1 503505 Musical Instruments 18 Lyre Guitar 15414 Lyre Guitar French 7         Maker 1 Possibly Joseph Pons French, born 1776 (probably a son of César Pons) Pons, Joseph 48007   1776 1876 ca. 1805 1795 1815 Mahogany, spruce, ebony, brass, nickel-silver, gilding 54897 Height: 34 1/4 in. (87 cm) Width: 14 3/8 in. (36.5 cm) Purchase, Clara Mertens Bequest, in memory of André Mertens, 1998   Paris 27     France 9             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
348984 89.4.2911 0 1 503708 Musical Instruments 18 Lyre Guitar 15414 Lyre Guitar French 7                           ca. 1830 1830 1830 Wood, paint, bone, glass 54999 Total L. 75 cm.; Max. w. 37.3 cm; Base depth: 12.1 cm; Vibrating length: 52.2 cm. The Crosby Brown Collection of Musical Instruments, 1889         France 9             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
349233 2002.106 0 0 504006 Musical Instruments 18 Lyre Guitar 15414 Lyre Guitar French 7                           ca. 1810 1800 1820 Wood, gilt brass 13412 H. 85.4 cm (33 5/8 in.), W. 34.3 cm (13 1/2 in.) Purchase, by subscription, by exchange, 2002         France 9             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
349961 89.4.2431 0 1 504801 Musical Instruments 18 Lyre Guitar 15414 Lyre Guitar European 12                           ca. 1800 1795 1805 Wood, ivory, metal 54037 L. 30 in. (76.2 cm) The Crosby Brown Collection of Musical Instruments, 1889                       Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 124.661ms · Data license: CC0 · Data source: metmuseum/openaccess